# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年12月04日
"""
import pandas as pd

pd.set_option('display.max_columns', 500)
pd.set_option('display.width', 1000)
pd.set_option('display.unicode.east_asian_width', True)

df = pd.read_excel('../source/mrbooks - 4.5.3.xls')
print(df.head())
print("=" * 30)
df1 = df.groupby(['宝贝标题'])['宝贝总数量'].sum().head()
mydict = df1.to_dict()
for i, j in mydict.items():
	print(i, ':\t', j)
